Not Equal operator

Basic and Crystal syntax.

Usage

x<>y

x is not equal to y.

The Not Equal operator tells the program to evaluate an expression (x<>y) and return a TRUE (if x is not equal to y) or FALSE (if x is equal to y).

Examples

The following examples are applicable to both Basic and Crystal syntax:

{orders.ORDER AMOUNT} <> 400

TRUE, where {orders.ORDER AMOUNT} is equal to 200 or {orders.ORDER AMOUNT} is equal to 401, etc.

{orders.ORDER AMOUNT} <> 400

FALSE, where {orders.ORDER AMOUNT} is equal to 400.

{file.DAY} <> "Thursday"

TRUE, when {file.DAY} = "Friday".

{file.DAY} <> "Thursday"

FALSE, when {file.DAY} = "Thursday".

{file.ONHAND} <>0

TRUE, where the value of {file.ONHAND} is 10 or -5.

{file.ONHAND} <>0

FALSE, where the value of {file.ONHAND} is zero.

{file.AVAILABLE} - {file.USED} <>10

TRUE, where the value of the {file.AVAILABLE} field less the value of the {file.USED} field gives a result other than 10.

{file.AVAILABLE} - {file.USED} <>10

FALSE, where it gives a value of 10.

Comments

This operator is often used with If-Then-Else operators. For example in Crystal syntax:

If {file.SEX} <> "M" Then

    "FEMALE"

Else

    "MALE"

Prints the word "FEMALE" if the value in the {file.SEX} field is not equal to "M", and prints the word "MALE" in all other situations.

Related topics

Formula 5

Formula 11

Formula 15



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com